Creating line and stacked column chart and map

Step 6

a.       Creating line and stacked column chart and map

On field and shared axis decade column, and also select Year and Month, column value success % and Line value DOD %

b.       To Format, Go to General X position = 2, y position = 148, width = 614, height = 336

c.        Legend font family =comic Sans MS, text 10 style =line and mark

d.       x-axis color white, text size 12, style comic Sans MS

e.       y-axis color(66B5FE) text size 10, style comic Sans MS and  title =off

f.          Gridlines on color (C8C8C8) stoke width 1, line style =dotted, show secondary= on Align zeros= On

g.       Y-Axis(line), color (FF8600) text Size 11 font family comic Sans MS, Title= off

h.       data Colors  ,DOD% = (FF8600), Default color( 018DA2)

i.         Data labels On, color white text size 11, font family comic sans MS, ,show background on , transparency  30%

j.         customize series on, success %, color (66B5FE) text size =11,

font family comic Sans MS, show background =on

k.        shapes area On, stroke width 1, join types Miter Line style solid

l.         Tittle on ‘TREND TERRORIST BY DECADE’ , word wrap on font color white, background color(018DA2),alignment = center , text size -15 font family =Cambria Math

m.     Background = off

n.       Lock aspect =off

o.       Border = off

p.       Tooltip = on

q.       Visual header= on

Step 7 just copy paste

a.       On field and shared axis  change it in to >>> weaptype1_txt,<<< and column value success % and Line value DOD% change the title to’ TERRORIST ATTACK TYPES’

Step 8  copy and paste  but choose Filled map

a.        On field and Location region_txt, Tooltips success % and DOD% change the title to

’TERRORST ACTIVITIES BY REGION’

Step 9 copy and paste the first chart

a.       On field and shared axis attacktype1, and column value success % and Line value DOD% change the title to’ TERRORIST ATTACK METHODS

Follow the Gif below.

CONTINUE.... WITH CHANGING THE SHAR AXIS AND FILED VALUES 


CONTINUE.... WITH CHANGING TITLE AND FORMATING  MAP.